Aditya Didwania

Many of us face the issue of forgot password of joomla administrator. The password cannot be reset suing the ‘Forgot password’ link on front-end of website. We need to reset it from database. I am listing here 3 methods to reset or recover joomla admin password.

Method I :- Using simple update SQL query.

Step 1 – Navigate to phpMyAdmin and select the database of the joomla wesbite.

Step 2 – Click SQL at top and run the following SQL query

UPDATE `#__users` SET `password` = MD5('NEW_PASSWORD') WHERE `username` = "admin" ;

Where: ‘#_’ is the table prefix
‘NEW_PASSWORD’ is the new password
Replace ‘admin’ with the username of you super user.

Method II :- Change password directly in the table.

Step 1 – Navigate to phpMyAdmin and select the database of the joomla wesbite.

Step 2 – Find and open the ‘#__users’ table and then click on edit icon for the super user you want t o reset.

Step 3 – Select md5 from the function dropdown beside password field and add new passwor in the password field.

Method III :- Creating new Super administrator.

Step 1 – Navigate to phpMyAdmin and select the database of the joomla wesbite.

Step 2 – Click SQL tab at the top and run the following SQL query.

INSERT INTO `#__users` (`name`, `username`, `password`, `params`) VALUES ('Administrator2', 'admin2', 'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '');
INSERT INTO `#__user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8');

– This will create a new super admin user with username: admin2 and password: secret.
– Make sure to change the password as soon as you login to admin.